RM Distribution Work File (RM10101)

azurecurve Products Microsoft Dynamics GP (0)SalesRM Distribution Work File (RM10101)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/RM10101

Product: Microsoft Dynamics GP (0)
Series: Sales

Display Name: RM Distribution Work File
Physical Name: RM10101
Technical Name: RM_Distribution_WORK

Group Display Name: Receivables Open Transaction Files
Group Technical Name: RM_Open_Transaction_Logical_File

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	TRXSORCE	TRX Source	String	STR13	13
2	POSTED	Posted	Boolean	True/False	0
3	POSTEDDT	Posted Date	Date	DATE	6
4	PSTGSTUS	Posting Status	Integer	INT	0
5	CHANGED	Changed	Boolean	YN	0
6	DOCNUMBR	Document Number	String	STR20_Document_Number	20
7	DCSTATUS	Document Status	Integer	DDL_Doc_Status	0
8	DISTTYPE	Distribution Type	Integer	DDL	0
9	RMDTYPAL	RM Document Type-All	Integer	INT2	2
	Document Type records the type of document. Click to show/hide the Document Types 0 Balance Carried Forward 1 Sales / Invoice 2 Scheduled Payments 3 Debit Memo 4 Finance Charge 5 Service Repairs 6 Warranties 7 Credit Memo 8 Returns 9 Payments
10	SEQNUMBR	Sequence Number	Long Integer	LI_Sequence_Number	10
11	CUSTNMBR	Customer Number	String	STR15_RM_Customer_Number	15
	Key to the RM Customer MSTR (RM00101). Click to show/hide SELECT ['RM Distribution Work File'].CUSTNMBR AS 'RM Distribution Work File-Customer Number' ,['RM Customer MSTR'].CUSTNMBR AS 'RM Customer MSTR-Customer Number' FROM RM10101 AS ['RM Distribution Work File'] INNER JOIN RM00101 AS ['RM Customer MSTR'] ON ['RM Distribution Work File'].CUSTNMBR = ['RM Customer MSTR'].CUSTNMBR
12	DSTINDX	Distribution Account Index	Long Integer	LI_14	14
	Key to the Account Index Master (GL00105). Click to show/hide SELECT ['RM Distribution Work File'].DSTINDX AS 'RM Distribution Work File-Distribution Account Index' ,['Account Index Master'].ACTINDX AS 'Account Index Master-Account Index' FROM RM10101 AS ['RM Distribution Work File'] INNER JOIN GL00105 AS ['Account Index Master'] ON ['RM Distribution Work File'].DSTINDX = ['Account Index Master'].ACTINDX
13	DEBITAMT	Debit Amount	Currency	DLR19_$S2	19
14	CRDTAMNT	Credit Amount	Currency	DLR19_$S2	19
15	PROJCTID	Project ID	String	STR15	15
16	USERID	User ID	String	STR15_User_ID	15
	Key to the Users Master (SY01400). Click to show/hide SELECT ['RM Distribution Work File'].USERID AS 'RM Distribution Work File-User ID' ,['Users Master'].USERID AS 'Users Master-User ID' FROM RM10101 AS ['RM Distribution Work File'] INNER JOIN DYNAMICS..SY01400 AS ['Users Master'] ON ['RM Distribution Work File'].USERID = ['Users Master'].USERID
17	CATEGUSD	Category Used	Integer	INT	0
18	CURNCYID	Currency ID	String	STR15_Currency_ID	15
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['RM Distribution Work File'].CURNCYID AS 'RM Distribution Work File-Currency ID' ,['Currency Setup'].CURNCYID AS 'Currency Setup-Currency ID' FROM RM10101 AS ['RM Distribution Work File'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['RM Distribution Work File'].CURNCYID = ['Currency Setup'].CURNCYID
19	CURRNIDX	Currency Index	Integer	INT3	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['RM Distribution Work File'].CURRNIDX AS 'RM Distribution Work File-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM RM10101 AS ['RM Distribution Work File'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['RM Distribution Work File'].CURRNIDX = ['Currency Setup'].CURRNIDX
20	ORCRDAMT	Originating Credit Amount	Currency	DLR19_$S2	19
21	ORDBTAMT	Originating Debit Amount	Currency	DLR19_$S2	19
22	DistRef	Distribution Reference	String	STR30	30

azurecurve Products Microsoft Dynamics GP (0)SalesRM Distribution Work File (RM10101)

Click to show/hide the Document Types

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Click to show/hide

Leave a Reply Cancel reply